Navicat allows you to transfer tables/views/functions/sequences/events from one database/schema to another database/schema, or to a sql file. The target database/schema can be on the same server as the source database/schema or on another server. It also allows you to save a profile for easy retrieval and running of data transfer between databases/schemas. You can also invoke data transfer from the command line, which makes it possible to schedule data transfer between databases/schemas. You can save your settings as a profile for setting schedule.
Simply open the data transfer and use the toolbar below, which allows you
to create, save and delete the data transfer.
Create Data Transfer
To create a new data transfer
- Select Tools -> Data Transfer from the main menu or just
select
New from the toolbar above.
- Edit data transfer properties on the appropriate tabs.
To create a new data transfer with modification as one of the existing data transfer profiles
- Select Tools -> Data Transfer from the main menu
- Select the data transfer for modifying from the Load Profile drop-down list.
- Modify data transfer properties on the appropriate tabs.
- Click
Save As.
Hint: To create new data transfer, you can also control-click the database/schema node in the navigation pane and select the Data Transfer from the popup menu.
Edit Data Transfer
To edit the existing data transfer
- Select Tools -> Data Transfer from the main menu.
- Select the data transfer for modifying from the Load Profile drop-down list.
- Modify data transfer properties on the appropriate tabs.
Run Data Transfer
To run a data transfer
- Create a new data transfer/open the existing one.
- Click
Start.
To run a saved data transfer profile from the command line
- Create and save data transfer profile.
- In terminal, type the command (see Command for details)
Delete Data Transfer
To delete a data transfer
- Select Tools -> Data Transfer from the main menu.
- Select the data transfer for dropping from the Load Profile drop-down list.
- Click the
Delete from the toolbar.